<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating a threshold for multiple metrics: Complex thresholds</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
h3.whs2 { margin-left:24px; }
img_whs3 { border:none; width:14px; height:18px; float:none; border-style:none; }
ol.whs4 { list-style:lower-alpha; }
ul.whs5 { list-style:decimal; }
img_whs6 { border:none; width:17px; height:17px; float:none; border-style:none; }
p.whs7 { font-weight:normal; }
ul.whs8 { list-style:disc; }
img_whs9 { border:none; width:16px; height:16px; float:none; border-style:none; }
img_whs10 { border:none; width:18px; height:16px; float:none; border-style:none; }
img_whs11 { border:none; width:17px; height:15px; float:none; border-style:none; }
p.whs12 { margin-left:0px; color:#000000; }
img_whs13 { border:none; width:16px; height:15px; float:none; border-style:none; }
img_whs14 { border:none; width:19px; height:19px; float:none; border-style:none; }
p.whs15 { margin-left:0px; color:#000000; font-weight:normal; }
h2.whs16 { font-size:9pt; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs12 {margin-left:1pt; }";
  strNSS += "p.whs15 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nAdding features for users\nHighlighting specific sets of data: Thresholds\nCreating a threshold for multiple metrics: Advanced thresholds");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating a threshold for multiple metrics: Advanced thresholds</h1>
<p>An advanced threshold is based on multiple metrics and uses more complex 
 expressions than a visual threshold. This allows for very specific conditions 
 to be defined, and a range of different formatting, images, or symbols 
 to be applied to values that meet these conditions. &nbsp;Advanced 
 thresholds can contain conditions based on metrics or attributes, and 
 a single advanced threshold can be based on multiple conditions.</p>
<p>For prerequisites, see 
<a href="Thresholds.htm">About thresholds</a>. 
 </p>
<h2>To create an advanced threshold</h2>
<ol type="1" class="whs1">
	
<li class=p><p>Run a report.</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Data </B></span>menu, 
 select <span style="font-weight: bold;"><B>Advanced Thresholds Editor</B></span>. 
 The Advanced Thresholds Editor opens. </p></li>
</ol>
<h3 class="whs2">Specify the threshold's conditions</h3>
<ol start="3" type="1" class="whs1">
	
<li class=p><p>From the drop-down list, select the metric for which 
 to create a threshold.</p></li>
	
<li class=p><p>Click <span style="font-weight: bold;"><B>New</B></span> <img src="images/thresholds.gif" x-maintain-ratio="TRUE" width="14px" height="18px" border="0" class="img_whs3"> 
 to begin creating a new threshold. </p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Filter On</B></span> 
 drop-down list, select the attribute or metric on which to base the threshold.</p></li>
	
<li class=p><p>If you are creating a condition based on a metric, do 
 the following: </p></li>
	<ol type="a" class="whs4">
		
<li class=p><p>Select a comparison operator such as Greater Than 
 or Less Than. </p></li>
		
<li class=p><p>Enter a value in the field on the right or click<span 
 style="font-weight: bold;"><B> Select Metric</B></span> to choose another metric 
 to compare the original metric to. </p></li>
	</ol>
</ol>
<ul type="1" class="whs5">
	<ol start="3" type="a" class="whs4">
		
<li class=p style="list-style: inside lower-alpha;" type=a>Click 
 <span style="font-weight: bold;"><B>Apply<img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs6"> </B></span><span>to create the new threshold.</span></li>
		
<li style="list-style: inside lower-alpha; font-weight: normal; " 
 type=a class=p><p class="whs7">Proceed to step 8.</p></li>
	</ol>
</ul>
<ol start="7" type="1" class="whs1">
	
<li class=p><p>If you are creating a condition based on an attribute, 
 you can define your condition either by selecting options from a list 
 or you can type your condition's definition. Use one of the following:</p></li>
</ol>
<ol><ul type="disc" class="whs8">
		
<li class=p><p class="whs7">To define your condition 
 by typing specific attribute elements:</p></li>
		<ol type="a" class="whs4">
			
<li class=p><p>Choose<span style="font-weight: bold;"><B> Qualify.</B></span></p></li>
			
<li class=p><p>From the drop-down list on the left, select 
 whether to base the condition on the attribute element's <span style="font-weight: bold;"><B>ID</B></span> 
 form, one of its description forms, or the <span style="font-weight: bold;"><B>DATE</B></span> 
 if the attribute is time-based.</p></li>
			
<li class=p><p>From the next drop-down list, select a comparison 
 operator such as Greater Than or Less Than. The operators available for 
 a selection depend on the attribute form you chose above.</p></li>
			
<li class=p><p>Click <span style="font-weight: bold;"><B>Attributes</B></span> 
 to choose attribute elements from a list. For example, if your condition 
 is based on the Call Center attribute, select Salt Lake City to apply 
 thresholds only to data for Salt Lake City.<span style="font-weight: bold;"> 
 <B></B></span></p></li>
			
<li class=p><p>Click Apply<span style="font-weight: bold;"> 
 <B><img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs6"> 
 </B></span>to create the new threshold.</p></li>
		</ol>
		
<li class=p><p class="whs7">To define your condition 
 by selecting attribute elements from a list:</p></li>
		<ol type="a" class="whs4">
			
<li class=p><p>Choose <span style="font-weight: bold;"><B>Select.</B></span></p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>F</B></span>rom 
 the drop-down list on the left, select<span style="font-weight: bold;"><B> 
 In List</B></span> or<span style="font-weight: bold;"><B> Not In List. </B></span>If 
 you select Not in List, then the attribute elements in the Selected list 
 will not be included in the threshold condition.<span style="font-weight: bold;"> 
 <B></B></span></p></li>
			
<li class=p><p>Move attribute elements from the<span style="font-weight: bold;"><B> 
 Available </B></span>list to the<span style="font-weight: bold;"><B> Selected 
 </B></span>list<span style="font-weight: bold;"><B>. E</B></span>lements in the Selected 
 list are included in the threshold condition.</p></li>
			
<li class=p><p><span style="font-weight: bold;"><B>T</B></span>o search 
 for a specific element, use the Search for field. Select the<span style="font-weight: bold;"><B> 
 Match case </B></span>check box to return only items that match the upper 
 and lower cases you typed in the Search for field. For examples of searches, 
 see<span style="font-weight: bold;"> <B>
<a href="Search_syntax.htm">Using 
 correct and efficient search syntax</a>.</B></span></p></li>
			
<li class=p><p>Click<span style="font-weight: bold;"><B> Apply 
 <img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs6"> 
 </B></span>to create the new threshold.</p></li>
		</ol>
	</ul>
</ol>
<ol start="8" type="1" class="whs1">
	
<li class=p><p>It is often convenient to make a copy of a threshold 
 if you plan to create similar thresholds in the report. To copy a threshold, 
 select the threshold in the Advanced Threshold Editor and click<span style="font-weight: bold;"><B> 
 Copy. </B></span>Then paste a copied threshold by selecting the threshold 
 and clicking<span style="font-weight: bold;"><B> Paste.</B></span></p></li>
	
<li class=p><p>To delete a threshold, select the threshold and click<span 
 style="font-weight: bold;"><B> Delete Threshold <img src="images/delete2.gif" x-maintain-ratio="TRUE" width="16px" height="16px" border="0" class="img_whs9"> .</B></span></p></li>
	
<li class=p><p>To move a threshold above or below other thresholds, 
 select the threshold and click<span style="font-weight: bold;"><B> Move up 
 </B></span>or<span style="font-weight: bold;"><B> Move down.</B></span></p></li>
	
<li class=p><p>To add an additional condition to a threshold, select 
 the threshold and click<span style="font-weight: bold;"><B> Add Condition 
 <img src="images/reportfilter.gif" x-maintain-ratio="TRUE" width="18px" height="16px" border="0" class="img_whs10">.</B></span></p></li>
	
<li class=p><p>To clear the conditions from a threshold, select the 
 threshold and click<span style="font-weight: bold;"><B> Clear Conditions 
 <img src="images/thresholdclear.gif" x-maintain-ratio="TRUE" width="17px" height="15px" border="0" class="img_whs11">.</B></span></p></li>
	
<li class=p><p><span style="font-weight: bold;"><B>To</B></span> specify how 
 data that meets the threshold is formatted, Click<span style="font-weight: bold;"><B> 
 Cell Formatting. </B></span>The Format dialog box opens. For steps to format 
 a threshold, see<span style="font-weight: bold;"> <B>
<a href="Format_Thresholds_Editor.htm">Format 
 Thresholds Editor</a>.</B></span></p></li>
</ol>
<ol start="14" type="1" class="whs1">
	
<li style=" color: #000000; " class=p><p class="whs12">Determine 
 whether a background color is applied to graph reports in which thresholds 
 are met, select<span style="font-weight: bold;"><B> Apply background color 
 to graph threshold <img src="images/graph2.gif" x-maintain-ratio="TRUE" width="16px" height="15px" border="0" class="img_whs13">.</B></span></p></li>
	
<li style=" color: #000000; " class=p><p class="whs12">To 
 have an email automatically delivered to you or other users when the threshold 
 is met, click<span style="font-weight: bold;"><B> Alert <img src="images/alert.gif" x-maintain-ratio="TRUE" width="19px" height="19px" border="0" class="img_whs14">. </B></span>For details on using the Alerts Editor, 
 see<span style="font-weight: bold;"> <B>
<a HREF="Alerts_thresholds.htm">Creating 
 alerts for specific threshold conditions</a>.</B></span></p></li>
	
<li style=" color: #000000; font-weight: normal; " class=p><p class="whs15">Determine 
 what parts of the report are formatted when a threshold is met. Select 
 one of the following options on the toolbar:</p></li>
</ol>
<ul><ul>
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs12">Format metrics only</p></li>
		
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs12">Format subtotals only</p></li>
		
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs12">Format metrics and subtotals</p></li>
	</ul>
</ul>
<ol start="17" type="1" class="whs1">
	
<li style=" color: #000000; font-weight: normal; " class=p><p class="whs15">To 
 add another threshold condition, select the area below the first threshold 
 and repeat steps 3-15 above.</p></li>
	
<li style=" color: #000000; font-weight: normal; " class=p><p class="whs15">Click 
 <span style="font-weight: bold;"><B>Apply</B></span> to apply the new threshold(s) 
 to the report.</p></li>
</ol>
<h2 class="whs16">Related topics</h2>
<ul>
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Thresholds_on_report.htm">Displaying 
 thresholds on a report</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Thresholds.htm">About 
 thresholds</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Add_predefined_thresholds.htm">Adding 
 a quick threshold to a report</a></p></li>
	
<li class=p-TopicTextBulleted><p class=TopicTextBulleted>
<a href="Create_simple_threshold.htm">Creating 
 a threshold for a metric based on a metric: Visual thresholds</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
